#!/usr/bin/env python3
# -*- coding: utf-8 -*-
from sqlalchemy import create_engine, Table, Column, Integer, String, DateTime, MetaData, ForeignKey
import pymysql

engine = create_engine("mysql+pymysql://root:root@localhost/test", echoe=True)

metaDate = MetaData(engine)

todo = Table('todo', metaDate,
             Column('id', Integer, primary_key=True),
             Column('content', String(40)),
             Column('time', DateTime),
             Column('status', Integer))

metaDate.create_all()
